3 visuals for webpage

This code will help produce the three visuals that are going to be a part of each equity tracker indicator webpage: regional map (tract level) of most recent data, chart of the most recent data, chart of trends over time.

If the indicator is available through a tract-level data set. Getting the data to a workable version may require some data transformation. To explore, clean, transform, and generate a final data set, please use the data-gen-tract-template. This script will generate an .rda for the map and an .rda for the charts. These data sets will be loaded in before the data visualization code.

Indicator Explanation

[Please include the following for a general, layperson audience: 1-2 sentences explaining what your indicator is/measures, what it says about people’s life outcomes; 1 sentence describing why it is useful/relevant in the indicator’s theme]

1. Map of most recent data

To map data in this form, there should be a value corresponding to each census tract. Depending on the year or source of the data, this could be about 700 rows for data at the 2010 census tract resolution, or about 900 rows for data at the 2020 census tract resolution.

Create Visual

Sources: U.S. Census Bureau, American Community Survey (ACS) 2021 5-Year Estimates; U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles



Data call outs

  1. 3.40 miles: The region’s average distance to high capacity transit (HCT)
  2. 31.99 miles: The census tract with the farthest average distance to HCT is in Snohomish County
  3. 0.06 miles: The census tract with the shortest average distance to HCT is in King County


Insights & Analysis

  • King County has the lowest average distance to HCT (2.49 miles), followed by Kitsap (4.34 miles), Pierce (4.37 miles), and Snohomish (4.59 miles)
  • Of the 10 census tracts with the farthest distance to HCT (all of which are over 18 miles), 4 are located in Snohomish County, 4 are in King, and 1 is in Pierce
  • There are 283 tracts in the region with an average distance to HCT less than one mile: 71% in King, 19% in Snohomish, 7% in Pierce, and 2% in Kitsap



2. Facet of most recent data

Create Visual

Distance to High Capacity Transit

The weighted distance in miles to high capacity transit (HCT) stations in 2021

GTFS (General Transit Feed Specification), U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)

Data call outs

  1. 3.5 miles: The average regional distance to HCT for people living in census tracts with the highest concentration of people of color, compared to 7.9 miles in census tracts with the lowest concentrations of people of color
  2. 4.3 miles: Those living in census tracts with the highest concentration of low income households are 4.3 miles closer to HCT than those living in census tracts with the lowest concentration
  3. 3.8 miles: Those living in census tracts with the highest concentration of households with youth are 3.8 miles farther from HCT than those living in census tracts with the lowest concentration


Insights & Analysis

  • The difference in distance to HCT between those living in census tracts with a high and low concentration of limited English proficient households is greatest in Snohomish (5.1 miles), Pierce (3.9 miles), King (2.9 miles), and Kitsap (1.2 miles)
  • There is no noticeable relationship between distance to HCT and and living in census tracts with high and low concentrations of people with disabilities
  • When comparing the life expectancy of those living in census tracts with the highest and lowest concentrations of households with children under 18 years old, life expectancy is slightly higher in King County (2.9 years) and Snohomish County (1.4 years) and much lower in Kitsap County (-22.4 years) and Pierce County (-9.3 years)



3. Facet of trend data

Create Visual

Distance to High Capacity Transit

The weighted distance in miles to high capacity transit (HCT) stations in 2021

GTFS (General Transit Feed Specification), U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)

Data call outs

  1. 3.9 years: The regional life expectancy gap between census tracts with the highest and lowest concentrations of people of color in 2010, a 15.8% smaller gap than in 2020
  2. 293%: The increase in the regional life expectancy gap between census tracts with the highest and lowest concentrations of households below 200% of the poverty line between 2010 and 2020
  3. 71.5 years: The 2020 regional life expectancy in tracts with the highest concentrations of households below 200% of the poverty line, 7 years fewer than the regional average (78.8) and 9 years fewer than the regional median (80.9)


Insights & Analysis

  • Snohomish County is the only county in the region where the life expectancy of the census tracts with the highest concentration of people of color exceeds the life expectancy of the census tracts with the lowest concentration of people of color, a trend consistent over the past decade
  • The life expectancy gaps between census tracts with the highest and lowest concentration of households below 200% of the poverty line increased in all counties between 2010 and 2020, with the largest gap change in Pierce County (7.2 years) and the smallest gap change in Kitsap County (1.6 years)
  • The 2020 life expectancy of those living in the census tracts with the highest concentrations of households with limited English proficiency is shortest in Pierce County (70.4 years), compared to King County () and Snohomish County (80.5 years)



Transfer files

Copy files from Github > Y drive

Copy files from Y drive > website folder

Back to top of the page